USE [demo]
GO
/****** Object:  Table [dbo].[COMPONENT_REGISTER]    Script Date: 06/12/2011 21:12:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[COMPONENT_REGISTER](
	[COMPONENT_REGISTER_GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_COMPONENT_REGISTER_COMPONENT_REGISTER_GUID]  DEFAULT (newid()),
	[COMPONENT_GUID] [uniqueidentifier] NOT NULL,
	[COMPONENT_TYPE] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NULL,
	[REGISTRATION_TIME] [datetime] NOT NULL CONSTRAINT [DF_COMPONENT_REGISTER_REGISTRATION_TIME]  DEFAULT (getdate()),
	[LAST_ACTIVITY] [datetime] NOT NULL CONSTRAINT [DF_COMPONENT_REGISTER_LAST_ACTIVITY]  DEFAULT (getdate()),
	[SUBJECT] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[MASTER] [int] NOT NULL CONSTRAINT [DF_COMPONENT_REGISTER_MASTER]  DEFAULT ((0)),
	[ENABLE_REDUNDANCY] [int] NOT NULL CONSTRAINT [DF_COMPONENT_REGISTER_ENABLE_REDUNDANCY]  DEFAULT ((0))
) ON [PRIMARY]
